How to: Define the data type for a field.
Solution:
In the Table Design view, click in the 'Data Type' column for the desired field. Then click on the arrow, and select a data type from the 'Data Type' drop-down list.
1) If the Database window is not active, activate the Database window.
2) Make sure the table is opened in the Table Design view.
3) Click in the 'Data Type' column for the desired field. (A down arrow appears in the cell.)
4) Click on the arrow in the 'Data Type' column for the desired field. (A drop-down list appears in the Data Type column.)
5) Select a data type from the 'Data Type' drop-down list.
Data type
6) To save the change, select the 'File' menu and select 'Save'.
7) To close the Table Design window, select the 'File' menu and select 'Close'.
